Mark Druffel

Data Scientist, Analytics Engineer

Experience

84.51°

Remote

Lead Data Scientist

Dec 2022 - Present

Lead team responsible for developing and supporting tools used by Kroger's marketing division to execute and learn from marketing campaigns.

  • Redesigned and developed a the campaign measurement data pipeline using Kedro, Ibis, and a medallion architecture which increased the pipeline's extensibility, maintainability, and performance.
  • Redesigned the data model for Kroger's campaign management app to make each module a composable microservice significantly improving the app's scalability. The new data model unlocked several new business capabilities, improved the app engineering team's velocity, and decreased measurement data processing times.

    • DocStation

    Remote

    Lead Data Scientist

    Apr 2021 - Dec 2022

    Founding member and first analytics hire for a seed funded start-up.

  • Expanded the data warehouse by developing data models in the pipeline with SQL, pyspark, and Airflow.
  • Designed and developed dashboards using Apache Superset and R Shiny, and the underlying infrastructure, used by business operations to make data-driven decisions.
  • Led ad hoc analysis projects that increased revenue by improving the app's task targeting for pharmacists (i.e. made tasks assigned more relevant).

    • Propeller

    Remote

    Analytics Consultant

    Jan 2017 - Apr 2021

    Worked with clients to develop their data strategies and road maps, and execute analytics and IT projects. Example clients include Nike, Salesforce, Kindercare, Cambia, and Mercy Corps.

  • Created a feedback loop between a product team and their end-users by developing a text analysis and NLP pipeline, which automatically identified user pain points.
  • Designed a prototype recruiting pipeline management app to enable an HR team to manage a data-driven recruitment process to improve consistency, velocity, and candidate experience.
  • Developed and facilitated analytics workshops to upskill client teams.
  • Developed internal analytics infrastructure to streamline Propeller’s operations including API wrappers, a data pipeline, and automated reporting using R, Python, and AWS.

    • Northern Trust

    Chicago, IL

    Manager, Reporting

    Oct 2015 - Dec 2016

    Mananged the reporting strategy, roadmap, and product development.

  • Designed a prototype d3.js dashboaring and reporting app that enabled users to view expressive, interactive reporting and collaborate with business partners.
  • Designed and developed a data pipeline that processed semi-structured and unstructured systems data to identify data processing bottleneck root causes, forecast server demand, and help measure and manage tech debt.

    • Team Lead, Reporting

    Sept 2013 - Oct 2015

    Led a global team of data analysts and operations analysts

  • Developed dashboards and static reports using Tableau, eGlue (homegrown), R, and Python.
  • Lowered the number of data quality issues in production by 2x by developing and managing ETL quality assurance processes including data transformation validation, data profiling, consistency checks, and data completeness checks.
  • Managed customer user access to SaaS apps and customer data exchanges.
  • Trained my team in Excel, SQL, Tableau, R, and Python

    • Plante Moran

    Chicago, IL

    Senior Auditor

    Mar 2013 - Sept 2013

    Project managed IT audits and risk assessments for clients in various industries

    Staff Auditor

    Jun 2011 - Mar 2013

    Performed IT audits and risk assessments for clients in various industries

    Fifth Third Bank

    Cincinnati, OH

    Staff Auditor

    Jun 2010 - Jun 2011

    Performed financial audits, IT audits, and risk assessments

    Education

    University of Notre Dame

    M.S in Business Analytics

    2016

    Ohio University

    Bachelors in Business Admin

    2010

    Coding